[dbo].[BAEImisGetProductFunctions]

SQLServer > iMIS1521GA > Stored Procedures > dbo.BAEImisGetProductFunctions

Properties
Parameters
SQL Script
Uses

Property	Value
ANSI Nulls On
Quoted Identifier On

Parameters

Name	Data Type	Max Length (Bytes)
@eventCode	varchar(31)	31

SQL Script

CREATE PROCEDURE [dbo].[BAEImisGetProductFunctions] @eventCode varchar(31)
AS
SELECT Product_Function.* FROM [dbo].[Product_Function]
    LEFT OUTER JOIN [dbo].[Product] ON Product_Function.[PRODUCT_CODE] = Product.[PRODUCT_CODE]
    WHERE Product.[PRODUCT_MAJOR] = @eventCode
    ORDER BY Product.[PRODUCT_CODE]

GO

Uses

[dbo].[Product]
[dbo].[Product_Function]
dbo